Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

JDeveloper and PostgreSQL

3121Aug 26 2002 — edited Sep 18 2003
Hello,

I am tried set JDeveloper with PostgreSQL (JDeveloper ver. 9.0.2.7.97,jdk 1.3.1_02)
I have used "SQL Server walktrough" for setting businnes components
My entity object is org_ban with 5 columns
id varchar(4)
ime,adr,zrt,zrs varchar(30)
View object is like entity object
I make simple JClient.
Select and delete with JClient (and business components tester) work fine, but
insert or update give me next error.

I have little java application and this work :

-----
import java.io.*;
import java.sql.*;
import java.text.*;

public class basic
{
Connection db;

public basic() throws ClassNotFoundException, FileNotFoundException, IOException, SQLException
{
Class.forName("org.postgresql.Driver");
db = DriverManager.getConnection("jdbc:postgresql://spnew/snpe", "snpe", "snpe");
PreparedStatement st = db.prepareStatement("INSERT INTO org_ban(\"id\",\"ime\") VALUES(?,?)");
st.setInt(1, 4);
st.setString(2,"Snpe banka");
int rowsInserted = st.executeUpdate();
System.out.println("Inserted row " + rowsInserted);
st.close();
db.close();
}

public static void main(String args[])
{
System.out.println("PostgreSQL little test \n");
try
{
basic test = new basic();
}
catch (Exception ex)
{
System.err.println("Exception caught.\n" + ex);
ex.printStackTrace();
}
}
}
---

Please help.

Stack trace :

oracle.jbo.SQLStmtException: JBO-27123: SQL error during call statement preparation. Statement: INSERT INTO org_ban("id","ime") VALUES (?,?)
at oracle.jbo.server.DBTransactionImpl.createCallableStatement(DBTransactionImpl.java:2455)
at oracle.jbo.server.BaseSQLBuilderImpl.doEntityDML(BaseSQLBuilderImpl.java:227)
at oracle.jbo.server.EntityImpl.doDML(EntityImpl.java:3907)
at oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:3157)
at oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:2073)
at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:2017)
at oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:1363)
at oracle.jbo.server.DBTransactionImpl.commit(DBTransactionImpl.java:1517)
at oracle.jbo.uicli.binding.JUApplication.commitTransaction(JUApplication.java:724)
at oracle.jbo.uicli.binding.JUCtrlActionBinding.doIt(JUCtrlActionBinding.java:314)
at oracle.jbo.uicli.jui.JUActionBinding.actionPerformed(JUActionBinding.java:117)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1450)
at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1504)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:378)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:250)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:216)
at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:230)
at java.awt.Component.processMouseEvent(Component.java:3715)
at java.awt.Component.processEvent(Component.java:3544)
at java.awt.Container.processEvent(Container.java:1164)
at java.awt.Component.dispatchEventImpl(Component.java:2593)
at java.awt.Container.dispatchEventImpl(Container.java:1213)
at java.awt.Component.dispatchEvent(Component.java:2497)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:2451)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:2216)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:2125)
at java.awt.Container.dispatchEventImpl(Container.java:1200)
at java.awt.Window.dispatchEventImpl(Window.java:926)
at java.awt.Component.dispatchEvent(Component.java:2497)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:339)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:131)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:98)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:85)
## Detail 0 ##
Malformed stmt [INSERT INTO org_ban("id","ime") VALUES (?,?)] usage : {[? =] call <some_function> ([? [,?]*]) }
at org.postgresql.jdbc2.CallableStatement.modifyJdbcCall(Unknown Source)
at org.postgresql.jdbc2.CallableStatement.parseSqlStmt(Unknown Source)
at org.postgresql.jdbc2.PreparedStatement.<init>(Unknown Source)
at org.postgresql.jdbc2.CallableStatement.<init>(Unknown Source)
at org.postgresql.jdbc2.Connection.prepareCall(Unknown Source)
at org.postgresql.jdbc2.Connection.prepareCall(Unknown Source)
at oracle.jbo.server.DBTransactionImpl.createCallableStatement(DBTransactionImpl.java:2420)
at oracle.jbo.server.BaseSQLBuilderImpl.doEntityDML(BaseSQLBuilderImpl.java:227)
at oracle.jbo.server.EntityImpl.doDML(EntityImpl.java:3907)
at oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:3157)
at oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:2073)
at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:2017)
at oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:1363)
at oracle.jbo.server.DBTransactionImpl.commit(DBTransactionImpl.java:1517)
at oracle.jbo.uicli.binding.JUApplication.commitTransaction(JUApplication.java:724)
at oracle.jbo.uicli.binding.JUCtrlActionBinding.doIt(JUCtrlActionBinding.java:314)
at oracle.jbo.uicli.jui.JUActionBinding.actionPerformed(JUActionBinding.java:117)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1450)
at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1504)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:378)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:250)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:216)
at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:230)
at java.awt.Component.processMouseEvent(Component.java:3715)
at java.awt.Component.processEvent(Component.java:3544)
at java.awt.Container.processEvent(Container.java:1164)
at java.awt.Component.dispatchEventImpl(Component.java:2593)
at java.awt.Container.dispatchEventImpl(Container.java:1213)
at java.awt.Component.dispatchEvent(Component.java:2497)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:2451)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:2216)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:2125)
at java.awt.Container.dispatchEventImpl(Container.java:1200)
at java.awt.Window.dispatchEventImpl(Window.java:926)
at java.awt.Component.dispatchEvent(Component.java:2497)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:339)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:131)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:98)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:85)

----- LEVEL 1: DETAIL 0 -----
Malformed stmt [INSERT INTO org_ban("id","ime") VALUES (?,?)] usage : {[? =] call <some_function> ([? [,?]*]) }
at org.postgresql.jdbc2.CallableStatement.modifyJdbcCall(Unknown Source)
at org.postgresql.jdbc2.CallableStatement.parseSqlStmt(Unknown Source)
at org.postgresql.jdbc2.PreparedStatement.<init>(Unknown Source)
at org.postgresql.jdbc2.CallableStatement.<init>(Unknown Source)
at org.postgresql.jdbc2.Connection.prepareCall(Unknown Source)
at org.postgresql.jdbc2.Connection.prepareCall(Unknown Source)
at oracle.jbo.server.DBTransactionImpl.createCallableStatement(DBTransactionImpl.java:2420)
at oracle.jbo.server.BaseSQLBuilderImpl.doEntityDML(BaseSQLBuilderImpl.java:227)
at oracle.jbo.server.EntityImpl.doDML(EntityImpl.java:3907)
at oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:3157)
at oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:2073)
at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:2017)
at oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:1363)
at oracle.jbo.server.DBTransactionImpl.commit(DBTransactionImpl.java:1517)
at oracle.jbo.uicli.binding.JUApplication.commitTransaction(JUApplication.java:724)
at oracle.jbo.uicli.binding.JUCtrlActionBinding.doIt(JUCtrlActionBinding.java:314)
at oracle.jbo.uicli.jui.JUActionBinding.actionPerformed(JUActionBinding.java:117)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1450)
at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1504)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:378)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:250)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:216)
at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:230)
at java.awt.Component.processMouseEvent(Component.java:3715)
at java.awt.Component.processEvent(Component.java:3544)
at java.awt.Container.processEvent(Container.java:1164)
at java.awt.Component.dispatchEventImpl(Component.java:2593)
at java.awt.Container.dispatchEventImpl(Container.java:1213)
at java.awt.Component.dispatchEvent(Component.java:2497)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:2451)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:2216)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:2125)
at java.awt.Container.dispatchEventImpl(Container.java:1200)
at java.awt.Window.dispatchEventImpl(Window.java:926)
at java.awt.Component.dispatchEvent(Component.java:2497)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:339)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:131)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:98)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:85)


Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 16 2003
Added on Aug 26 2002
8 comments
462 views