middlegen error with oracle
can somebody tell me what's the problem?
I can use other tools like pl sql developper.

D:\Program Files\Middlegen-Hibernate-r5>ant -file custom.build.xml
Buildfile: custom.build.xml

init:

fail-if-no-xdoclet-1.2:

check-driver-present:

panic-if-driver-not-present:

middlegen:
[echo] Class path = D:\Program Files\Middlegen-Hibernate-r5
[middlegen] (middlegen.Middlegen 350 ) Registering plugin simple
->middlegen.Plugin
[middlegen] (middlegen.Middlegen 350 ) Registering plugin java->
middlegen.javax.JavaPlugin
[middlegen] (middlegen.Middlegen 350 ) Registering plugin plugin
->middlegen.Plugin
[middlegen] (middlegen.Middlegen 350 ) Registering plugin hibern
ate->middlegen.plugins.hibernate.HibernatePlugin
[middlegen] Database URL:jdbc:oracle:thin:@82.22.16.17:1521:example

BUILD FAILED
D:\Program Files\Middlegen-Hibernate-r5\custom.build.xml:149: middlegen.Middlege
nException: Couldn't connect to database: ORA-01017: invalid username/password;
logon denied


Total time: 10 seconds
D:\Program Files\Middlegen-Hibernate-r5>ant -file custom.build.xml
Buildfile: custom.build.xml

init:

fail-if-no-xdoclet-1.2:

check-driver-present:

panic-if-driver-not-present:

middlegen:
[echo] Class path = D:\Program Files\Middlegen-Hibernate-r5
[middlegen] (middlegen.Middlegen 350 ) Registering plugin simple
->middlegen.Plugin
[middlegen] (middlegen.Middlegen 350 ) Registering plugin java->
middlegen.javax.JavaPlugin
[middlegen] (middlegen.Middlegen 350 ) Registering plugin plugin
->middlegen.Plugin
[middlegen] (middlegen.Middlegen 350 ) Registering plugin hibern
ate->middlegen.plugins.hibernate.HibernatePlugin
[middlegen] Database URL:jdbc:oracle:thin:@82.22.16.17:1521:example
[middlegen] (middlegen.MiddlegenPopulator 249 ) ORA-04031: unable to allo
cate 68 bytes of shared memory ("shared pool","SELECT NULL AS table_cat,
[middlegen] ...","sql area","optdef : apalks")

[middlegen] java.sql.SQLException: ORA-04031: unable to allocate 68 bytes of sha
red memory ("shared pool","SELECT NULL AS table_cat,
[middlegen] ...","sql area","optdef : apalks")

[middlegen] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseEr
ror.java:125)
[middlegen] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)

[middlegen] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)

[middlegen] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
[middlegen] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedSt
atement.java:181)
[middlegen] at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(
T4CPreparedStatement.java:420)
[middlegen] at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(Ora
cleStatement.java:896)
[middlegen] at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describ
e(T4CPreparedStatement.java:452)
[middlegen] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Oracl
eStatement.java:986)
[middlegen] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(Or
aclePreparedStatement.java:2888)
[middlegen] at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(Oracl
ePreparedStatement.java:2929)
[middlegen] at oracle.jdbc.OracleDatabaseMetaData.getPrimaryKeys(OracleDatab
aseMetaData.java:2820)
[middlegen] at middlegen.MiddlegenPopulator.addColumns(MiddlegenPopulator.ja
va:889)
[middlegen] at middlegen.MiddlegenPopulator.populate(MiddlegenPopulator.java
:217)
[middlegen] at middlegen.MiddlegenTask.execute(MiddlegenTask.java:432)
[middlegen] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.ja
va:275)
[middlegen] at org.apache.tools.ant.Task.perform(Task.java:364)
[middlegen] at org.apache.tools.ant.Target.execute(Target.java:341)
[middlegen] at org.apache.tools.ant.Target.performTasks(Target.java:369)
[middlegen] at org.apache.tools.ant.Project.executeTarget(Project.java:1214)

[middlegen] at org.apache.tools.ant.Project.executeTargets(Project.java:1062
)
[middlegen] at org.apache.tools.ant.Main.runBuild(Main.java:673)
[middlegen] at org.apache.tools.ant.Main.startAnt(Main.java:188)
[middlegen] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:196)
[middlegen] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:55)

BUILD FAILED
D:\Program Files\Middlegen-Hibernate-r5\custom.build.xml:149: middlegen.Middlege
nException: Database problem:ORA-04031: unable to allocate 68 bytes of shared me
mory ("shared pool","SELECT NULL AS table_cat,
...","sql area","optdef : apalks")


Total time: 7 minutes 0 seconds
D:\Program Files\Middlegen-Hibernate-r5>

HI,

You have two errors there

and some other byte allocation problem.

I think your JDBC driver is broken or your setup is: plsql is a C++ application and Middlegen uses JAVA. Oracle is not normally a problem. I suggest you check your version and the JDBC driiver etc, then your environment.

middlegen.Middlege
nException: Database problem:ORA-04031: unable to allocate 68 bytes of shared me
mory ("shared pool","SELECT NULL AS table_cat,
...","sql area","optdef : apalks")

your means that I 've to change the drivers ?
that is the most possible reasons?

I have never seen that error. My first feeling is that its a database setup/configuration issue but I trust you have other tools including oracle client talking to it. What about other Java based applications?
Sometimes I code a small JDBC connection class that gets some meta data to test these situations. Check you environment - sorry but I have no specific ideas that may solve this issue.

I've changed more than one jdbc drivers. such as classes2.jar , jodbc14.jar

but it still casted the error.

I can use quantum eclipse database plugin to connect to the oracle.

It can list all the tables and execute sqls.


beforetime, I've connected to the Oracle Server of customer.
I don't know what happened.