You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tomee.apache.org by mikespan <mi...@netscape.net> on 2012/10/01 20:40:33 UTC

Getting a persistence exception using openjpa jta datasource

I'm getting the following exception when trying to persist data using a jta
configured data source

<openjpa-2.2.0-r422266:1244990 fatal general error>
org.apache.openjpa.persistence.PersistenceException: invalid authorization
specification - not found: root

My datasource is listed in tomee.xml

<Resource id="jdbc/mysql" type="javax.sql.DataSource">
	# configure the pool
	DataSourceCreator = tomcat
	# it is a jta datasource
	JtaManaged = true
	# tomcat pool configuration
	driverClassName = com.mysql.jdbc.Driver
	url =
jdbc:mysql://localhost:3306/adaptiveauth?noAccessToProcedureBodies=true
	username = root
	password = *******
	validationQuery = SELECT 1
	maxActive=4
	maxIdle=2
	maxWait=-1
	jmxEnabled = true # specific to tomcat pooling
</Resource>

My persistence.xml is

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd">
  <persistence-unit name="analyticsPU" transaction-type="JTA">
    <jta-data-source>jdbc/mysql</jta-data-source>
    <properties>
  	<property name="openjpa.jdbc.SynchronizeMappings"
value="buildSchema(foreignKeys=true,schemaAction='dropDB,add')"/>
  	<property name="openjpa.jdbc.SchemaFactory"
value="native(foreignKeys=true)" />
  	<property name="openjpa.jdbc.MappingDefaults"
value="ForeignKeyDeleteAction=restrict,
JoinForeignKeyDeleteAction=restrict"/>
  	<property name="openjpa.Log" value="DefaultLevel=TRACE,SQL=TRACE" />
    </properties>
  </persistence-unit>
</persistence>

My web.xml has

    <persistence-unit-ref>
       
<persistence-unit-ref-name>persistence-factory</persistence-unit-ref-name>
        <persistence-unit-name>analyticsPU</persistence-unit-name>
    </persistence-unit-ref>


Code to create EntityManagerFactory

return (EntityManagerFactory) new
InitialContext().lookup("java:comp/env/persistence-factory");

Below is the log trace for openjpa when trying to open a connection


13776  analyticsPU  INFO   [http-bio-10080-exec-1] openjpa.Runtime -
Starting OpenJPA 2.2.0
13777  analyticsPU  TRACE  [http-bio-10080-exec-1] openjpa.Runtime -
Properties: javax.persistence.lock.timeout: 0
javax.persistence.query.timeout: 0
javax.persistence.sharedCache.mode: UNSPECIFIED
javax.persistence.validation.group.pre-persist:
javax.validation.groups.Default
javax.persistence.validation.group.pre-update:
javax.validation.groups.Default
javax.persistence.validation.mode: AUTO
openjpa.AutoClear: 0
openjpa.AutoDetach: []
openjpa.BrokerFactory: jdbc
openjpa.BrokerImpl: non-finalizing
openjpa.CacheDistributionPolicy: default
openjpa.Callbacks: default
openjpa.ClassResolver:
org.apache.openjpa.persistence.PersistenceUnitInfoImpl$ClassResolverImpl
openjpa.Compatibility: default
openjpa.ConnectionFactoryMode: true
openjpa.ConnectionRetainMode: 0
openjpa.DataCache: false
openjpa.DataCacheManager: default
openjpa.DataCacheTimeout: -1
openjpa.DetachState: loaded
openjpa.DynamicDataStructs: false
openjpa.DynamicEnhancementAgent: true
openjpa.EntityManagerFactory: default
openjpa.FetchBatchSize: -1
openjpa.FetchGroups: [default]
openjpa.FlushBeforeQueries: 0
openjpa.Id: analyticsPU
openjpa.IgnoreChanges: false
openjpa.InitializeEagerly: false
openjpa.InstrumentationManager: default
openjpa.InverseManager: false
openjpa.LifecycleEventManager: validating
openjpa.LockManager: mixed
openjpa.Log: true(DefaultLevel=TRACE,SQL=TRACE)
openjpa.ManagedRuntime: auto
openjpa.MaxFetchDepth: -1
openjpa.MetaDataFactory:
jpa(Files=/C:/opt/tomcat7/webapps/analytics/WEB-INF/classes/)
openjpa.MetaDataRepository: default
openjpa.Multithreaded: false
openjpa.NontransactionalRead: true
openjpa.NontransactionalWrite: true
openjpa.Optimistic: true
openjpa.OptimizeIdCopy: false
openjpa.OrphanedKeyAction: log
openjpa.PostLoadOnMerge: false
openjpa.ProxyManager: default
openjpa.QueryCache: false
openjpa.QueryCompilationCache: true
openjpa.ReadLockLevel: 10
openjpa.RefreshFromDataCache: false
openjpa.RestoreState: 1
openjpa.RetainState: true
openjpa.RetryClassRegistration: false
openjpa.RuntimeUnenhancedClasses: 0
openjpa.SavepointManager: in-mem
openjpa.Sequence: table
openjpa.TransactionMode: true
openjpa.WriteLockLevel: 20
openjpa.jdbc.DriverDataSource: auto
openjpa.jdbc.EagerFetchMode: 2
openjpa.jdbc.FetchDirection: 1000
openjpa.jdbc.FinderCache: true
openjpa.jdbc.IdentifierUtil: default
openjpa.jdbc.LRSSize: 2
openjpa.jdbc.MappingDefaults: jpa(ForeignKeyDeleteAction=restrict,
JoinForeignKeyDeleteAction=restrict)
openjpa.jdbc.QuerySQLCache: true
openjpa.jdbc.ResultSetType: 1003
openjpa.jdbc.SQLFactory: default
openjpa.jdbc.SchemaFactory: native(foreignKeys=true)
openjpa.jdbc.Schemas: []
openjpa.jdbc.SubclassFetchMode: 1
openjpa.jdbc.SynchronizeMappings:
buildSchema(foreignKeys=true,schemaAction='dropDB,add')
openjpa.jdbc.TransactionIsolation: -1
openjpa.jdbc.UpdateManager: default
13814  analyticsPU  TRACE  [http-bio-10080-exec-1] openjpa.Runtime - No
cache marshaller found for id
org.apache.openjpa.conf.MetaDataCacheMaintenance.
13903  analyticsPU  TRACE  [http-bio-10080-exec-1] openjpa.MetaData - Using
metadata factory
"org.apache.openjpa.persistence.jdbc.PersistenceMappingFactory@1da817b".
13907  analyticsPU  TRACE  [http-bio-10080-exec-1] openjpa.jdbc.JDBC -
OpenJPA will now connect to the database to attempt to determine what type
of database dictionary to use. You may prevent this connection in the future
by setting your openjpa.jdbc.DBDictionary configuration property to the
appropriate value for your database (see the documentation for available
values).
13921  analyticsPU  TRACE  [http-bio-10080-exec-1] openjpa.jdbc.JDBC -
createConnectionFactory:
DataSource:org.apache.openejb.resource.jdbc.managed.local.ManagedDataSource@121f653
Oct 1, 2012 10:44:46 AM org.hsqldb.persist.Logger logInfoEvent
INFO: checkpointClose start
Oct 1, 2012 10:44:46 AM org.hsqldb.persist.Logger logInfoEvent
INFO: checkpointClose end
14503  analyticsPU  TRACE  [http-bio-10080-exec-1] openjpa.Runtime - No
cache marshaller found for id
org.apache.openjpa.conf.MetaDataCacheMaintenance.
14503  analyticsPU  TRACE  [http-bio-10080-exec-1] openjpa.MetaData - Using
metadata factory
"org.apache.openjpa.persistence.jdbc.PersistenceMappingFactory@1613fe7".
14503  analyticsPU  TRACE  [http-bio-10080-exec-1] openjpa.jdbc.JDBC -
OpenJPA will now connect to the database to attempt to determine what type
of database dictionary to use. You may prevent this connection in the future
by setting your openjpa.jdbc.DBDictionary configuration property to the
appropriate value for your database (see the documentation for available
values).
14523  analyticsPU  TRACE  [http-bio-10080-exec-1] openjpa.jdbc.JDBC -
createConnectionFactory:
DataSource:org.apache.openejb.resource.jdbc.managed.local.ManagedDataSource@121f653
Oct 1, 2012 10:44:46 AM
com.adaptiveauth.rest.server.resources.InspectionResourceBase postInspection
INFO: <openjpa-2.2.0-r422266:1244990 fatal general error>
org.apache.openjpa.persistence.PersistenceException: invalid authorization
specification - not found: root


Don't know what kind of authorization is required for my user 'root' since
that user has all privileges on the database.




--
View this message in context: http://openejb.979440.n4.nabble.com/Getting-a-persistence-exception-using-openjpa-jta-datasource-tp4657731.html
Sent from the OpenEJB Dev mailing list archive at Nabble.com.

Re: Getting a persistence exception using openjpa jta datasource

Posted by Romain Manni-Bucau <rm...@gmail.com>.
remove your comment (#xxx) and go to catalina part of the MBeans

you should find your datasource here

*Romain Manni-Bucau*
*Twitter: @rmannibucau <https://twitter.com/rmannibucau>*
*Blog: **http://rmannibucau.wordpress.com/*<http://rmannibucau.wordpress.com/>
*LinkedIn: **http://fr.linkedin.com/in/rmannibucau*
*Github: https://github.com/rmannibucau*




2012/10/1 mikespan <mi...@netscape.net>

> Can you provide a link to setup JMX monitoring for configuration. Tried
> looking but not sure the correct sample to use.
>
> Here is the complete log trace when a EntityManagerFactory is created using
> openjpa. Everything looks good until the end when the em.persist call is
> made
>
> 19247  analyticsPU  INFO   [http-bio-10080-exec-8] openjpa.Runtime -
> Starting OpenJPA 2.2.0
> 19248  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.Runtime -
> Properties: javax.persistence.lock.timeout: 0
> javax.persistence.query.timeout: 0
> javax.persistence.sharedCache.mode: UNSPECIFIED
> javax.persistence.validation.group.pre-persist:
> javax.validation.groups.Default
> javax.persistence.validation.group.pre-update:
> javax.validation.groups.Default
> javax.persistence.validation.mode: AUTO
> openjpa.AutoClear: 0
> openjpa.AutoDetach: []
> openjpa.BrokerFactory: jdbc
> openjpa.BrokerImpl: non-finalizing
> openjpa.CacheDistributionPolicy: default
> openjpa.Callbacks: default
> openjpa.ClassResolver:
> org.apache.openjpa.persistence.PersistenceUnitInfoImpl$ClassResolverImpl
> openjpa.Compatibility: default
> openjpa.ConnectionFactoryMode: true
> openjpa.ConnectionRetainMode: 0
> openjpa.DataCache: false
> openjpa.DataCacheManager: default
> openjpa.DataCacheTimeout: -1
> openjpa.DetachState: loaded
> openjpa.DynamicDataStructs: false
> openjpa.DynamicEnhancementAgent: true
> openjpa.EntityManagerFactory: default
> openjpa.FetchBatchSize: -1
> openjpa.FetchGroups: [default]
> openjpa.FlushBeforeQueries: 0
> openjpa.Id: analyticsPU
> openjpa.IgnoreChanges: false
> openjpa.InitializeEagerly: false
> openjpa.InstrumentationManager: default
> openjpa.InverseManager: false
> openjpa.LifecycleEventManager: validating
> openjpa.LockManager: mixed
> openjpa.Log: true(DefaultLevel=TRACE,SQL=TRACE)
> openjpa.ManagedRuntime: auto
> openjpa.MaxFetchDepth: -1
> openjpa.MetaDataFactory:
> jpa(Files=/C:/opt/tomcat7/webapps/analytics/WEB-INF/classes/)
> openjpa.MetaDataRepository: default
> openjpa.Multithreaded: false
> openjpa.NontransactionalRead: true
> openjpa.NontransactionalWrite: true
> openjpa.Optimistic: true
> openjpa.OptimizeIdCopy: false
> openjpa.OrphanedKeyAction: log
> openjpa.PostLoadOnMerge: false
> openjpa.ProxyManager: default
> openjpa.QueryCache: false
> openjpa.QueryCompilationCache: true
> openjpa.ReadLockLevel: 10
> openjpa.RefreshFromDataCache: false
> openjpa.RestoreState: 1
> openjpa.RetainState: true
> openjpa.RetryClassRegistration: false
> openjpa.RuntimeUnenhancedClasses: 0
> openjpa.SavepointManager: in-mem
> openjpa.Sequence: table
> openjpa.TransactionMode: true
> openjpa.WriteLockLevel: 20
> openjpa.jdbc.DriverDataSource: auto
> openjpa.jdbc.EagerFetchMode: 2
> openjpa.jdbc.FetchDirection: 1000
> openjpa.jdbc.FinderCache: true
> openjpa.jdbc.IdentifierUtil: default
> openjpa.jdbc.LRSSize: 2
> openjpa.jdbc.MappingDefaults: jpa(ForeignKeyDeleteAction=restrict,
> JoinForeignKeyDeleteAction=restrict)
> openjpa.jdbc.QuerySQLCache: true
> openjpa.jdbc.ResultSetType: 1003
> openjpa.jdbc.SQLFactory: default
> openjpa.jdbc.SchemaFactory: native(foreignKeys=true)
> openjpa.jdbc.Schemas: []
> openjpa.jdbc.SubclassFetchMode: 1
> openjpa.jdbc.SynchronizeMappings:
> buildSchema(foreignKeys=true,schemaAction='dropDB,add')
> openjpa.jdbc.TransactionIsolation: -1
> openjpa.jdbc.UpdateManager: default
> 19387  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.Runtime - No
> cache marshaller found for id
> org.apache.openjpa.conf.MetaDataCacheMaintenance.
> 19436  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.MetaData - Using
> metadata factory
> "org.apache.openjpa.persistence.jdbc.PersistenceMappingFactory@1e2c00f".
> 19439  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.jdbc.JDBC -
> OpenJPA will now connect to the database to attempt to determine what type
> of database dictionary to use. You may prevent this connection in the
> future
> by setting your openjpa.jdbc.DBDictionary configuration property to the
> appropriate value for your database (see the documentation for available
> values).
> 19461  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.jdbc.JDBC -
> createConnectionFactory:
>
> DataSource:org.apache.openejb.resource.jdbc.managed.local.ManagedDataSource@17e7691
> 19787  analyticsPU  INFO   [http-bio-10080-exec-8] openjpa.jdbc.JDBC -
> Using
> dictionary class "org.apache.openjpa.jdbc.sql.MySQLDictionary" (MySQL
> 5.1.45-community ,MySQL-AB JDBC Driver mysql-connector-java-5.1.6 (
> Revision: ${svn.Revision} )).
> 19809  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.jdbc.JDBC -
> catalogSeparator: .
> catalogTerm: database
> databaseProductName: MySQL
> databaseProductVersion: 5.1.45-community
> driverName: MySQL-AB JDBC Driver
> driverVersion: mysql-connector-java-5.1.6 ( Revision: ${svn.Revision} )
> extraNameCharacters: #@
> identifierQuoteString: `
> numericFunctions:
>
> ABS,ACOS,ASIN,ATAN,ATAN2,BIT_COUNT,CEILING,COS,COT,DEGREES,EXP,FLOOR,LOG,LOG10,MAX,MIN,MOD,PI,POW,POWER,RADIANS,RAND,ROUND,SIN,SQRT,TAN,TRUNCATE
> procedureTerm: PROCEDURE
> schemaTerm:
> searchStringEscape: \
> sqlKeywords:
>
> ACCESSIBLE,ANALYZE,ASENSITIVE,BEFORE,BIGINT,BINARY,BLOB,CALL,CHANGE,CONDITION,DATABASE,DATABASES,DAY_HOUR,DAY_MICROSECOND,DAY_MINUTE,DAY_SECOND,DELAYED,DETERMINISTIC,DISTINCTROW,DIV,DUAL,EACH,ELSEIF,ENCLOSED,ESCAPED,EXIT,EXPLAIN,FLOAT4,FLOAT8,FORCE,FULLTEXT,HIGH_PRIORITY,HOUR_MICROSECOND,HOUR_MINUTE,HOUR_SECOND,IF,IGNORE,INFILE,INOUT,INT1,INT2,INT3,INT4,INT8,ITERATE,KEYS,KILL,LEAVE,LIMIT,LINEAR,LINES,LOAD,LOCALTIME,LOCALTIMESTAMP,LOCK,LONG,LONGBLOB,LONGTEXT,LOOP,LOW_PRIORITY,MEDIUMBLOB,MEDIUMINT,MEDIUMTEXT,MIDDLEINT,MINUTE_MICROSECOND,MINUTE_SECOND,MOD,MODIFIES,NO_WRITE_TO_BINLOG,OPTIMIZE,OPTIONALLY,OUT,OUTFILE,PURGE,RANGE,READS,READ_ONLY,READ_WRITE,REGEXP,RELEASE,RENAME,REPEAT,REPLACE,REQUIRE,RETURN,RLIKE,SCHEMAS,SECOND_MICROSECOND,SENSITIVE,SEPARATOR,SHOW,SPATIAL,SPECIFIC,SQLEXCEPTION,SQL_BIG_RESULT,SQL_CALC_FOUND_ROWS,SQL_SMALL_RESULT,SSL,STARTING,STRAIGHT_JOIN,TERMINATED,TINYBLOB,TINYINT,TINYTEXT,TRIGGER,UNDO,UNLOCK,UNSIGNED,USE,UTC_DATE,UTC_TIME,UTC_TIMESTAMP,VARBINARY,VARCHARACTER,WHILE,X509,XOR,YEAR_MONTH,ZEROFILL
> stringFunctions:
>
> ASCII,BIN,BIT_LENGTH,CHAR,CHARACTER_LENGTH,CHAR_LENGTH,CONCAT,CONCAT_WS,CONV,ELT,EXPORT_SET,FIELD,FIND_IN_SET,HEX,INSERT,INSTR,LCASE,LEFT,LENGTH,LOAD_FILE,LOCATE,LOCATE,LOWER,LPAD,LTRIM,MAKE_SET,MATCH,MID,OCT,OCTET_LENGTH,ORD,POSITION,QUOTE,REPEAT,REPLACE,REVERSE,RIGHT,RPAD,RTRIM,SOUNDEX,SPACE,STRCMP,SUBSTRING,SUBSTRING,SUBSTRING,SUBSTRING,SUBSTRING_INDEX,TRIM,UCASE,UPPER
> systemFunctions:
>
> DATABASE,USER,SYSTEM_USER,SESSION_USER,PASSWORD,ENCRYPT,LAST_INSERT_ID,VERSION
> timeDateFunctions:
>
> DAYOFWEEK,WEEKDAY,DAYOFMONTH,DAYOFYEAR,MONTH,DAYNAME,MONTHNAME,QUARTER,WEEK,YEAR,HOUR,MINUTE,SECOND,PERIOD_ADD,PERIOD_DIFF,TO_DAYS,FROM_DAYS,DATE_FORMAT,TIME_FORMAT,CURDATE,CURRENT_DATE,CURTIME,CURRENT_TIME,NOW,SYSDATE,CURRENT_TIMESTAMP,UNIX_TIMESTAMP,FROM_UNIXTIME,SEC_TO_TIME,TIME_TO_SEC
> url:
> jdbc:mysql://localhost:3306/adaptiveauth?noAccessToProcedureBodies=true
> userName: root@localhost
> defaultTransactionIsolation: 2
> driverMajorVersion: 5
> driverMinorVersion: 1
> maxBinaryLiteralLength: 16777208
> maxCatalogNameLength: 32
> maxCharLiteralLength: 16777208
> maxColumnNameLength: 64
> maxColumnsInGroupBy: 64
> maxColumnsInIndex: 16
> maxColumnsInOrderBy: 64
> maxColumnsInSelect: 256
> maxColumnsInTable: 512
> maxConnections: 0
> maxCursorNameLength: 64
> maxIndexLength: 256
> maxProcedureNameLength: 0
> maxRowSize: 2147483639
> maxSchemaNameLength: 0
> maxStatementLength: 65531
> maxStatements: 0
> maxTableNameLength: 64
> maxTablesInSelect: 256
> maxUserNameLength: 16
> isCatalogAtStart: true
> isReadOnly: false
> nullPlusNonNullIsNull: true
> nullsAreSortedAtEnd: false
> nullsAreSortedAtStart: false
> nullsAreSortedHigh: false
> nullsAreSortedLow: true
> storesLowerCaseIdentifiers: true
> storesLowerCaseQuotedIdentifiers: true
> storesMixedCaseIdentifiers: false
> storesMixedCaseQuotedIdentifiers: false
> storesUpperCaseIdentifiers: false
> storesUpperCaseQuotedIdentifiers: true
> supportsAlterTableWithAddColumn: true
> supportsAlterTableWithDropColumn: true
> supportsANSI92EntryLevelSQL: true
> supportsANSI92FullSQL: false
> supportsANSI92IntermediateSQL: false
> supportsCatalogsInDataManipulation: true
> supportsCatalogsInIndexDefinitions: true
> supportsCatalogsInPrivilegeDefinitions: true
> supportsCatalogsInProcedureCalls: true
> supportsCatalogsInTableDefinitions: true
> supportsColumnAliasing: true
> supportsConvert: false
> supportsCoreSQLGrammar: true
> supportsCorrelatedSubqueries: true
> supportsDataDefinitionAndDataManipulationTransactions: false
> supportsDataManipulationTransactionsOnly: false
> supportsDifferentTableCorrelationNames: true
> supportsExpressionsInOrderBy: true
> supportsExtendedSQLGrammar: false
> supportsFullOuterJoins: false
> supportsGroupBy: true
> supportsGroupByBeyondSelect: true
> supportsGroupByUnrelated: true
> supportsIntegrityEnhancementFacility: false
> supportsLikeEscapeClause: true
> supportsLimitedOuterJoins: true
> supportsMinimumSQLGrammar: true
> supportsMixedCaseIdentifiers: false
> supportsMixedCaseQuotedIdentifiers: false
> supportsMultipleResultSets: false
> supportsMultipleTransactions: true
> supportsNonNullableColumns: true
> supportsOpenCursorsAcrossCommit: false
> supportsOpenCursorsAcrossRollback: false
> supportsOpenStatementsAcrossCommit: false
> supportsOpenStatementsAcrossRollback: false
> supportsOrderByUnrelated: false
> supportsOuterJoins: true
> supportsPositionedDelete: false
> supportsPositionedUpdate: false
> supportsSchemasInDataManipulation: false
> supportsSchemasInIndexDefinitions: false
> supportsSchemasInPrivilegeDefinitions: false
> supportsSchemasInProcedureCalls: false
> supportsSchemasInTableDefinitions: false
> supportsSelectForUpdate: true
> supportsStoredProcedures: true
> supportsSubqueriesInComparisons: true
> supportsSubqueriesInExists: true
> supportsSubqueriesInIns: true
> supportsSubqueriesInQuantifieds: true
> supportsTableCorrelationNames: true
> supportsTransactions: true
> supportsUnion: true
> supportsUnionAll: true
> usesLocalFilePerTable: false
> usesLocalFiles: false
> allProceduresAreCallable: false
> allTablesAreSelectable: false
> dataDefinitionCausesTransactionCommit: true
> dataDefinitionIgnoredInTransactions: false
> doesMaxRowSizeIncludeBlobs: true
> supportsBatchUpdates: true
> 19811  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.jdbc.JDBC -
> Initial connection autoCommit: true, holdability: 2, TransactionIsolation:
> 4
> 19814  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.jdbc.JDBC - <t
> 21987351, conn 27724273> [0 ms] close
> 19866  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.jdbc.JDBC -
> createConnectionFactory:
>
> DataSource:org.apache.openejb.resource.jdbc.managed.local.ManagedDataSource@17e7691
> 19868  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.jdbc.JDBC - <t
> 21987351, conn 6175440> [1 ms] close
> 19872  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.jdbc.JDBC -
> DataSource connection setAutoCommit to "false"
> 19882  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.jdbc.JDBC - <t
> 21987351, conn 23854573> [0 ms] close
> 19947  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.Runtime - Found
> datasource 2: datasource 21158020 from config. StoreContext: null
> 19959  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.MetaData -
> Scanning directory "C:\opt\tomcat7\webapps\analytics\WEB-INF\classes" for
> persistent types.
> 19968  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.MetaData -
> Skipping persistent type location association for location
>
> "file:/C:/opt/tomcat7/webapps/analytics/WEB-INF/classes/com/adaptiveauth/db/jpa/impl/Headercontext.class"
> since it is a class, and will not need to be re-parsed later.
> 19968  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.MetaData - Scan
> of "C:\opt\tomcat7\webapps\analytics\WEB-INF\classes" found persistent
> types
> [com.adaptiveauth.db.jpa.impl.Headercontext].
> 19968  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.MetaData -
> Skipping persistent type location association for location
>
> "file:/C:/opt/tomcat7/webapps/analytics/WEB-INF/classes/com/adaptiveauth/db/jpa/impl/Riskcontext.class"
> since it is a class, and will not need to be re-parsed later.
> 20016  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.MetaData - Scan
> of "C:\opt\tomcat7\webapps\analytics\WEB-INF\classes" found persistent
> types
> [com.adaptiveauth.db.jpa.impl.Riskcontext].
> 20016  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.MetaData -
> Skipping persistent type location association for location
>
> "file:/C:/opt/tomcat7/webapps/analytics/WEB-INF/classes/com/adaptiveauth/db/jpa/impl/Cookiecontext.class"
> since it is a class, and will not need to be re-parsed later.
> 20016  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.MetaData - Scan
> of "C:\opt\tomcat7\webapps\analytics\WEB-INF\classes" found persistent
> types
> [com.adaptiveauth.db.jpa.impl.Cookiecontext].
> 20066  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.MetaData -
> Scanning resource "META-INF/orm.xml" for persistent types.
> 20067  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.MetaData - The
> persistent unit root url is
> "file:/C:/opt/tomcat7/webapps/analytics/WEB-INF/classes/"
> 20067  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.MetaData -
> parsePersistentTypeNames() found
> [com.adaptiveauth.db.jpa.impl.Headercontext,
> com.adaptiveauth.db.jpa.impl.Riskcontext,
> com.adaptiveauth.db.jpa.impl.Cookiecontext].
> 20116  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.MetaData - Found
> 3 classes with metadata in 157 milliseconds.
> 20172  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.Runtime - Found
> datasource1: datasource 25065105 from configuration. StoreContext:
> org.apache.openjpa.kernel.BrokerImpl@8e683a
>
> INFO: <openjpa-2.2.0-r422266:1244990 nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: $Proxy109
>
>
>
>
> --
> View this message in context:
> http://openejb.979440.n4.nabble.com/Getting-a-persistence-exception-using-openjpa-jta-datasource-tp4657731p4657735.html
> Sent from the OpenEJB Dev mailing list archive at Nabble.com.
>

Re: Getting a persistence exception using openjpa jta datasource

Posted by mikespan <mi...@netscape.net>.
Can you provide a link to setup JMX monitoring for configuration. Tried
looking but not sure the correct sample to use. 

Here is the complete log trace when a EntityManagerFactory is created using
openjpa. Everything looks good until the end when the em.persist call is
made

19247  analyticsPU  INFO   [http-bio-10080-exec-8] openjpa.Runtime -
Starting OpenJPA 2.2.0
19248  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.Runtime -
Properties: javax.persistence.lock.timeout: 0
javax.persistence.query.timeout: 0
javax.persistence.sharedCache.mode: UNSPECIFIED
javax.persistence.validation.group.pre-persist:
javax.validation.groups.Default
javax.persistence.validation.group.pre-update:
javax.validation.groups.Default
javax.persistence.validation.mode: AUTO
openjpa.AutoClear: 0
openjpa.AutoDetach: []
openjpa.BrokerFactory: jdbc
openjpa.BrokerImpl: non-finalizing
openjpa.CacheDistributionPolicy: default
openjpa.Callbacks: default
openjpa.ClassResolver:
org.apache.openjpa.persistence.PersistenceUnitInfoImpl$ClassResolverImpl
openjpa.Compatibility: default
openjpa.ConnectionFactoryMode: true
openjpa.ConnectionRetainMode: 0
openjpa.DataCache: false
openjpa.DataCacheManager: default
openjpa.DataCacheTimeout: -1
openjpa.DetachState: loaded
openjpa.DynamicDataStructs: false
openjpa.DynamicEnhancementAgent: true
openjpa.EntityManagerFactory: default
openjpa.FetchBatchSize: -1
openjpa.FetchGroups: [default]
openjpa.FlushBeforeQueries: 0
openjpa.Id: analyticsPU
openjpa.IgnoreChanges: false
openjpa.InitializeEagerly: false
openjpa.InstrumentationManager: default
openjpa.InverseManager: false
openjpa.LifecycleEventManager: validating
openjpa.LockManager: mixed
openjpa.Log: true(DefaultLevel=TRACE,SQL=TRACE)
openjpa.ManagedRuntime: auto
openjpa.MaxFetchDepth: -1
openjpa.MetaDataFactory:
jpa(Files=/C:/opt/tomcat7/webapps/analytics/WEB-INF/classes/)
openjpa.MetaDataRepository: default
openjpa.Multithreaded: false
openjpa.NontransactionalRead: true
openjpa.NontransactionalWrite: true
openjpa.Optimistic: true
openjpa.OptimizeIdCopy: false
openjpa.OrphanedKeyAction: log
openjpa.PostLoadOnMerge: false
openjpa.ProxyManager: default
openjpa.QueryCache: false
openjpa.QueryCompilationCache: true
openjpa.ReadLockLevel: 10
openjpa.RefreshFromDataCache: false
openjpa.RestoreState: 1
openjpa.RetainState: true
openjpa.RetryClassRegistration: false
openjpa.RuntimeUnenhancedClasses: 0
openjpa.SavepointManager: in-mem
openjpa.Sequence: table
openjpa.TransactionMode: true
openjpa.WriteLockLevel: 20
openjpa.jdbc.DriverDataSource: auto
openjpa.jdbc.EagerFetchMode: 2
openjpa.jdbc.FetchDirection: 1000
openjpa.jdbc.FinderCache: true
openjpa.jdbc.IdentifierUtil: default
openjpa.jdbc.LRSSize: 2
openjpa.jdbc.MappingDefaults: jpa(ForeignKeyDeleteAction=restrict,
JoinForeignKeyDeleteAction=restrict)
openjpa.jdbc.QuerySQLCache: true
openjpa.jdbc.ResultSetType: 1003
openjpa.jdbc.SQLFactory: default
openjpa.jdbc.SchemaFactory: native(foreignKeys=true)
openjpa.jdbc.Schemas: []
openjpa.jdbc.SubclassFetchMode: 1
openjpa.jdbc.SynchronizeMappings:
buildSchema(foreignKeys=true,schemaAction='dropDB,add')
openjpa.jdbc.TransactionIsolation: -1
openjpa.jdbc.UpdateManager: default
19387  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.Runtime - No
cache marshaller found for id
org.apache.openjpa.conf.MetaDataCacheMaintenance.
19436  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.MetaData - Using
metadata factory
"org.apache.openjpa.persistence.jdbc.PersistenceMappingFactory@1e2c00f".
19439  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.jdbc.JDBC -
OpenJPA will now connect to the database to attempt to determine what type
of database dictionary to use. You may prevent this connection in the future
by setting your openjpa.jdbc.DBDictionary configuration property to the
appropriate value for your database (see the documentation for available
values).
19461  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.jdbc.JDBC -
createConnectionFactory:
DataSource:org.apache.openejb.resource.jdbc.managed.local.ManagedDataSource@17e7691
19787  analyticsPU  INFO   [http-bio-10080-exec-8] openjpa.jdbc.JDBC - Using
dictionary class "org.apache.openjpa.jdbc.sql.MySQLDictionary" (MySQL
5.1.45-community ,MySQL-AB JDBC Driver mysql-connector-java-5.1.6 (
Revision: ${svn.Revision} )).
19809  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.jdbc.JDBC -
catalogSeparator: .
catalogTerm: database
databaseProductName: MySQL
databaseProductVersion: 5.1.45-community
driverName: MySQL-AB JDBC Driver
driverVersion: mysql-connector-java-5.1.6 ( Revision: ${svn.Revision} )
extraNameCharacters: #@
identifierQuoteString: `
numericFunctions:
ABS,ACOS,ASIN,ATAN,ATAN2,BIT_COUNT,CEILING,COS,COT,DEGREES,EXP,FLOOR,LOG,LOG10,MAX,MIN,MOD,PI,POW,POWER,RADIANS,RAND,ROUND,SIN,SQRT,TAN,TRUNCATE
procedureTerm: PROCEDURE
schemaTerm: 
searchStringEscape: \
sqlKeywords:
ACCESSIBLE,ANALYZE,ASENSITIVE,BEFORE,BIGINT,BINARY,BLOB,CALL,CHANGE,CONDITION,DATABASE,DATABASES,DAY_HOUR,DAY_MICROSECOND,DAY_MINUTE,DAY_SECOND,DELAYED,DETERMINISTIC,DISTINCTROW,DIV,DUAL,EACH,ELSEIF,ENCLOSED,ESCAPED,EXIT,EXPLAIN,FLOAT4,FLOAT8,FORCE,FULLTEXT,HIGH_PRIORITY,HOUR_MICROSECOND,HOUR_MINUTE,HOUR_SECOND,IF,IGNORE,INFILE,INOUT,INT1,INT2,INT3,INT4,INT8,ITERATE,KEYS,KILL,LEAVE,LIMIT,LINEAR,LINES,LOAD,LOCALTIME,LOCALTIMESTAMP,LOCK,LONG,LONGBLOB,LONGTEXT,LOOP,LOW_PRIORITY,MEDIUMBLOB,MEDIUMINT,MEDIUMTEXT,MIDDLEINT,MINUTE_MICROSECOND,MINUTE_SECOND,MOD,MODIFIES,NO_WRITE_TO_BINLOG,OPTIMIZE,OPTIONALLY,OUT,OUTFILE,PURGE,RANGE,READS,READ_ONLY,READ_WRITE,REGEXP,RELEASE,RENAME,REPEAT,REPLACE,REQUIRE,RETURN,RLIKE,SCHEMAS,SECOND_MICROSECOND,SENSITIVE,SEPARATOR,SHOW,SPATIAL,SPECIFIC,SQLEXCEPTION,SQL_BIG_RESULT,SQL_CALC_FOUND_ROWS,SQL_SMALL_RESULT,SSL,STARTING,STRAIGHT_JOIN,TERMINATED,TINYBLOB,TINYINT,TINYTEXT,TRIGGER,UNDO,UNLOCK,UNSIGNED,USE,UTC_DATE,UTC_TIME,UTC_TIMESTAMP,VARBINARY,VARCHARACTER,WHILE,X509,XOR,YEAR_MONTH,ZEROFILL
stringFunctions:
ASCII,BIN,BIT_LENGTH,CHAR,CHARACTER_LENGTH,CHAR_LENGTH,CONCAT,CONCAT_WS,CONV,ELT,EXPORT_SET,FIELD,FIND_IN_SET,HEX,INSERT,INSTR,LCASE,LEFT,LENGTH,LOAD_FILE,LOCATE,LOCATE,LOWER,LPAD,LTRIM,MAKE_SET,MATCH,MID,OCT,OCTET_LENGTH,ORD,POSITION,QUOTE,REPEAT,REPLACE,REVERSE,RIGHT,RPAD,RTRIM,SOUNDEX,SPACE,STRCMP,SUBSTRING,SUBSTRING,SUBSTRING,SUBSTRING,SUBSTRING_INDEX,TRIM,UCASE,UPPER
systemFunctions:
DATABASE,USER,SYSTEM_USER,SESSION_USER,PASSWORD,ENCRYPT,LAST_INSERT_ID,VERSION
timeDateFunctions:
DAYOFWEEK,WEEKDAY,DAYOFMONTH,DAYOFYEAR,MONTH,DAYNAME,MONTHNAME,QUARTER,WEEK,YEAR,HOUR,MINUTE,SECOND,PERIOD_ADD,PERIOD_DIFF,TO_DAYS,FROM_DAYS,DATE_FORMAT,TIME_FORMAT,CURDATE,CURRENT_DATE,CURTIME,CURRENT_TIME,NOW,SYSDATE,CURRENT_TIMESTAMP,UNIX_TIMESTAMP,FROM_UNIXTIME,SEC_TO_TIME,TIME_TO_SEC
url: jdbc:mysql://localhost:3306/adaptiveauth?noAccessToProcedureBodies=true
userName: root@localhost
defaultTransactionIsolation: 2
driverMajorVersion: 5
driverMinorVersion: 1
maxBinaryLiteralLength: 16777208
maxCatalogNameLength: 32
maxCharLiteralLength: 16777208
maxColumnNameLength: 64
maxColumnsInGroupBy: 64
maxColumnsInIndex: 16
maxColumnsInOrderBy: 64
maxColumnsInSelect: 256
maxColumnsInTable: 512
maxConnections: 0
maxCursorNameLength: 64
maxIndexLength: 256
maxProcedureNameLength: 0
maxRowSize: 2147483639
maxSchemaNameLength: 0
maxStatementLength: 65531
maxStatements: 0
maxTableNameLength: 64
maxTablesInSelect: 256
maxUserNameLength: 16
isCatalogAtStart: true
isReadOnly: false
nullPlusNonNullIsNull: true
nullsAreSortedAtEnd: false
nullsAreSortedAtStart: false
nullsAreSortedHigh: false
nullsAreSortedLow: true
storesLowerCaseIdentifiers: true
storesLowerCaseQuotedIdentifiers: true
storesMixedCaseIdentifiers: false
storesMixedCaseQuotedIdentifiers: false
storesUpperCaseIdentifiers: false
storesUpperCaseQuotedIdentifiers: true
supportsAlterTableWithAddColumn: true
supportsAlterTableWithDropColumn: true
supportsANSI92EntryLevelSQL: true
supportsANSI92FullSQL: false
supportsANSI92IntermediateSQL: false
supportsCatalogsInDataManipulation: true
supportsCatalogsInIndexDefinitions: true
supportsCatalogsInPrivilegeDefinitions: true
supportsCatalogsInProcedureCalls: true
supportsCatalogsInTableDefinitions: true
supportsColumnAliasing: true
supportsConvert: false
supportsCoreSQLGrammar: true
supportsCorrelatedSubqueries: true
supportsDataDefinitionAndDataManipulationTransactions: false
supportsDataManipulationTransactionsOnly: false
supportsDifferentTableCorrelationNames: true
supportsExpressionsInOrderBy: true
supportsExtendedSQLGrammar: false
supportsFullOuterJoins: false
supportsGroupBy: true
supportsGroupByBeyondSelect: true
supportsGroupByUnrelated: true
supportsIntegrityEnhancementFacility: false
supportsLikeEscapeClause: true
supportsLimitedOuterJoins: true
supportsMinimumSQLGrammar: true
supportsMixedCaseIdentifiers: false
supportsMixedCaseQuotedIdentifiers: false
supportsMultipleResultSets: false
supportsMultipleTransactions: true
supportsNonNullableColumns: true
supportsOpenCursorsAcrossCommit: false
supportsOpenCursorsAcrossRollback: false
supportsOpenStatementsAcrossCommit: false
supportsOpenStatementsAcrossRollback: false
supportsOrderByUnrelated: false
supportsOuterJoins: true
supportsPositionedDelete: false
supportsPositionedUpdate: false
supportsSchemasInDataManipulation: false
supportsSchemasInIndexDefinitions: false
supportsSchemasInPrivilegeDefinitions: false
supportsSchemasInProcedureCalls: false
supportsSchemasInTableDefinitions: false
supportsSelectForUpdate: true
supportsStoredProcedures: true
supportsSubqueriesInComparisons: true
supportsSubqueriesInExists: true
supportsSubqueriesInIns: true
supportsSubqueriesInQuantifieds: true
supportsTableCorrelationNames: true
supportsTransactions: true
supportsUnion: true
supportsUnionAll: true
usesLocalFilePerTable: false
usesLocalFiles: false
allProceduresAreCallable: false
allTablesAreSelectable: false
dataDefinitionCausesTransactionCommit: true
dataDefinitionIgnoredInTransactions: false
doesMaxRowSizeIncludeBlobs: true
supportsBatchUpdates: true
19811  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.jdbc.JDBC -
Initial connection autoCommit: true, holdability: 2, TransactionIsolation: 4
19814  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.jdbc.JDBC - <t
21987351, conn 27724273> [0 ms] close
19866  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.jdbc.JDBC -
createConnectionFactory:
DataSource:org.apache.openejb.resource.jdbc.managed.local.ManagedDataSource@17e7691
19868  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.jdbc.JDBC - <t
21987351, conn 6175440> [1 ms] close
19872  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.jdbc.JDBC -
DataSource connection setAutoCommit to "false"
19882  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.jdbc.JDBC - <t
21987351, conn 23854573> [0 ms] close
19947  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.Runtime - Found
datasource 2: datasource 21158020 from config. StoreContext: null
19959  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.MetaData -
Scanning directory "C:\opt\tomcat7\webapps\analytics\WEB-INF\classes" for
persistent types.
19968  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.MetaData -
Skipping persistent type location association for location
"file:/C:/opt/tomcat7/webapps/analytics/WEB-INF/classes/com/adaptiveauth/db/jpa/impl/Headercontext.class"
since it is a class, and will not need to be re-parsed later.
19968  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.MetaData - Scan
of "C:\opt\tomcat7\webapps\analytics\WEB-INF\classes" found persistent types
[com.adaptiveauth.db.jpa.impl.Headercontext].
19968  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.MetaData -
Skipping persistent type location association for location
"file:/C:/opt/tomcat7/webapps/analytics/WEB-INF/classes/com/adaptiveauth/db/jpa/impl/Riskcontext.class"
since it is a class, and will not need to be re-parsed later.
20016  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.MetaData - Scan
of "C:\opt\tomcat7\webapps\analytics\WEB-INF\classes" found persistent types
[com.adaptiveauth.db.jpa.impl.Riskcontext].
20016  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.MetaData -
Skipping persistent type location association for location
"file:/C:/opt/tomcat7/webapps/analytics/WEB-INF/classes/com/adaptiveauth/db/jpa/impl/Cookiecontext.class"
since it is a class, and will not need to be re-parsed later.
20016  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.MetaData - Scan
of "C:\opt\tomcat7\webapps\analytics\WEB-INF\classes" found persistent types
[com.adaptiveauth.db.jpa.impl.Cookiecontext].
20066  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.MetaData -
Scanning resource "META-INF/orm.xml" for persistent types.
20067  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.MetaData - The
persistent unit root url is
"file:/C:/opt/tomcat7/webapps/analytics/WEB-INF/classes/"
20067  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.MetaData -
parsePersistentTypeNames() found
[com.adaptiveauth.db.jpa.impl.Headercontext,
com.adaptiveauth.db.jpa.impl.Riskcontext,
com.adaptiveauth.db.jpa.impl.Cookiecontext].
20116  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.MetaData - Found
3 classes with metadata in 157 milliseconds.
20172  analyticsPU  TRACE  [http-bio-10080-exec-8] openjpa.Runtime - Found
datasource1: datasource 25065105 from configuration. StoreContext:
org.apache.openjpa.kernel.BrokerImpl@8e683a

INFO: <openjpa-2.2.0-r422266:1244990 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: $Proxy109




--
View this message in context: http://openejb.979440.n4.nabble.com/Getting-a-persistence-exception-using-openjpa-jta-datasource-tp4657731p4657735.html
Sent from the OpenEJB Dev mailing list archive at Nabble.com.

Re: Getting a persistence exception using openjpa jta datasource

Posted by Romain Manni-Bucau <rm...@gmail.com>.
please share more logs or even a sample reproducing it otherwise that's
pretty impossible to help you

FYI you should be able to valid your config through JMX

*Romain Manni-Bucau*
*Twitter: @rmannibucau <https://twitter.com/rmannibucau>*
*Blog: **http://rmannibucau.wordpress.com/*<http://rmannibucau.wordpress.com/>
*LinkedIn: **http://fr.linkedin.com/in/rmannibucau*
*Github: https://github.com/rmannibucau*




2012/10/1 mikespan <mi...@netscape.net>

> Thanks for the reply. Got further along following conventions my tomee.xml
> now looks like
>
> <Resource id="jdbc/mysql" type="javax.sql.DataSource">
>         # configure the pool
>         DataSourceCreator tomcat
>         # it is a jta datasource
>         JtaManaged true
>         # tomcat pool configuration
>         JdbcDriver com.mysql.jdbc.Driver
>         JdbcUrl
> jdbc:mysql://localhost:3306/adaptiveauth?noAccessToProcedureBodies=true
>         UserName root
>         Password adminl8g3e7
>         ValidationQuery SELECT 1
>         MaxActive 4
>         MaxIdle 2
>         MaxWait -1
>         JmxEnabled true # specific to tomcat pooling
> </Resource>
>
>
> But getting new error.
> INFO: <openjpa-2.2.0-r422266:1244990 nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: $Proxy109
>
> Don't know what Proxy109 means
>
>
>
> --
> View this message in context:
> http://openejb.979440.n4.nabble.com/Getting-a-persistence-exception-using-openjpa-jta-datasource-tp4657731p4657733.html
> Sent from the OpenEJB Dev mailing list archive at Nabble.com.
>

Re: Getting a persistence exception using openjpa jta datasource

Posted by mikespan <mi...@netscape.net>.
Thanks for the reply. Got further along following conventions my tomee.xml
now looks like

<Resource id="jdbc/mysql" type="javax.sql.DataSource">
	# configure the pool
	DataSourceCreator tomcat
	# it is a jta datasource
	JtaManaged true
	# tomcat pool configuration
	JdbcDriver com.mysql.jdbc.Driver
	JdbcUrl
jdbc:mysql://localhost:3306/adaptiveauth?noAccessToProcedureBodies=true
	UserName root
	Password adminl8g3e7
	ValidationQuery SELECT 1
	MaxActive 4
	MaxIdle 2
	MaxWait -1
	JmxEnabled true # specific to tomcat pooling
</Resource>


But getting new error. 
INFO: <openjpa-2.2.0-r422266:1244990 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: $Proxy109

Don't know what Proxy109 means



--
View this message in context: http://openejb.979440.n4.nabble.com/Getting-a-persistence-exception-using-openjpa-jta-datasource-tp4657731p4657733.html
Sent from the OpenEJB Dev mailing list archive at Nabble.com.

Re: Getting a persistence exception using openjpa jta datasource

Posted by Romain Manni-Bucau <rm...@gmail.com>.
Hi,

can you try adding UserName please? (respecting the case)

*Romain Manni-Bucau*
*Twitter: @rmannibucau <https://twitter.com/rmannibucau>*
*Blog: **http://rmannibucau.wordpress.com/*<http://rmannibucau.wordpress.com/>
*LinkedIn: **http://fr.linkedin.com/in/rmannibucau*
*Github: https://github.com/rmannibucau*




2012/10/1 mikespan <mi...@netscape.net>

> I'm getting the following exception when trying to persist data using a jta
> configured data source
>
> <openjpa-2.2.0-r422266:1244990 fatal general error>
> org.apache.openjpa.persistence.PersistenceException: invalid authorization
> specification - not found: root
>
> My datasource is listed in tomee.xml
>
> <Resource id="jdbc/mysql" type="javax.sql.DataSource">
>         # configure the pool
>         DataSourceCreator = tomcat
>         # it is a jta datasource
>         JtaManaged = true
>         # tomcat pool configuration
>         driverClassName = com.mysql.jdbc.Driver
>         url =
> jdbc:mysql://localhost:3306/adaptiveauth?noAccessToProcedureBodies=true
>         username = root
>         password = *******
>         validationQuery = SELECT 1
>         maxActive=4
>         maxIdle=2
>         maxWait=-1
>         jmxEnabled = true # specific to tomcat pooling
> </Resource>
>
> My persistence.xml is
>
> <?xml version="1.0" encoding="UTF-8"?>
> <persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
> http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd">
>   <persistence-unit name="analyticsPU" transaction-type="JTA">
>     <jta-data-source>jdbc/mysql</jta-data-source>
>     <properties>
>         <property name="openjpa.jdbc.SynchronizeMappings"
> value="buildSchema(foreignKeys=true,schemaAction='dropDB,add')"/>
>         <property name="openjpa.jdbc.SchemaFactory"
> value="native(foreignKeys=true)" />
>         <property name="openjpa.jdbc.MappingDefaults"
> value="ForeignKeyDeleteAction=restrict,
> JoinForeignKeyDeleteAction=restrict"/>
>         <property name="openjpa.Log" value="DefaultLevel=TRACE,SQL=TRACE"
> />
>     </properties>
>   </persistence-unit>
> </persistence>
>
> My web.xml has
>
>     <persistence-unit-ref>
>
> <persistence-unit-ref-name>persistence-factory</persistence-unit-ref-name>
>         <persistence-unit-name>analyticsPU</persistence-unit-name>
>     </persistence-unit-ref>
>
>
> Code to create EntityManagerFactory
>
> return (EntityManagerFactory) new
> InitialContext().lookup("java:comp/env/persistence-factory");
>
> Below is the log trace for openjpa when trying to open a connection
>
>
> 13776  analyticsPU  INFO   [http-bio-10080-exec-1] openjpa.Runtime -
> Starting OpenJPA 2.2.0
> 13777  analyticsPU  TRACE  [http-bio-10080-exec-1] openjpa.Runtime -
> Properties: javax.persistence.lock.timeout: 0
> javax.persistence.query.timeout: 0
> javax.persistence.sharedCache.mode: UNSPECIFIED
> javax.persistence.validation.group.pre-persist:
> javax.validation.groups.Default
> javax.persistence.validation.group.pre-update:
> javax.validation.groups.Default
> javax.persistence.validation.mode: AUTO
> openjpa.AutoClear: 0
> openjpa.AutoDetach: []
> openjpa.BrokerFactory: jdbc
> openjpa.BrokerImpl: non-finalizing
> openjpa.CacheDistributionPolicy: default
> openjpa.Callbacks: default
> openjpa.ClassResolver:
> org.apache.openjpa.persistence.PersistenceUnitInfoImpl$ClassResolverImpl
> openjpa.Compatibility: default
> openjpa.ConnectionFactoryMode: true
> openjpa.ConnectionRetainMode: 0
> openjpa.DataCache: false
> openjpa.DataCacheManager: default
> openjpa.DataCacheTimeout: -1
> openjpa.DetachState: loaded
> openjpa.DynamicDataStructs: false
> openjpa.DynamicEnhancementAgent: true
> openjpa.EntityManagerFactory: default
> openjpa.FetchBatchSize: -1
> openjpa.FetchGroups: [default]
> openjpa.FlushBeforeQueries: 0
> openjpa.Id: analyticsPU
> openjpa.IgnoreChanges: false
> openjpa.InitializeEagerly: false
> openjpa.InstrumentationManager: default
> openjpa.InverseManager: false
> openjpa.LifecycleEventManager: validating
> openjpa.LockManager: mixed
> openjpa.Log: true(DefaultLevel=TRACE,SQL=TRACE)
> openjpa.ManagedRuntime: auto
> openjpa.MaxFetchDepth: -1
> openjpa.MetaDataFactory:
> jpa(Files=/C:/opt/tomcat7/webapps/analytics/WEB-INF/classes/)
> openjpa.MetaDataRepository: default
> openjpa.Multithreaded: false
> openjpa.NontransactionalRead: true
> openjpa.NontransactionalWrite: true
> openjpa.Optimistic: true
> openjpa.OptimizeIdCopy: false
> openjpa.OrphanedKeyAction: log
> openjpa.PostLoadOnMerge: false
> openjpa.ProxyManager: default
> openjpa.QueryCache: false
> openjpa.QueryCompilationCache: true
> openjpa.ReadLockLevel: 10
> openjpa.RefreshFromDataCache: false
> openjpa.RestoreState: 1
> openjpa.RetainState: true
> openjpa.RetryClassRegistration: false
> openjpa.RuntimeUnenhancedClasses: 0
> openjpa.SavepointManager: in-mem
> openjpa.Sequence: table
> openjpa.TransactionMode: true
> openjpa.WriteLockLevel: 20
> openjpa.jdbc.DriverDataSource: auto
> openjpa.jdbc.EagerFetchMode: 2
> openjpa.jdbc.FetchDirection: 1000
> openjpa.jdbc.FinderCache: true
> openjpa.jdbc.IdentifierUtil: default
> openjpa.jdbc.LRSSize: 2
> openjpa.jdbc.MappingDefaults: jpa(ForeignKeyDeleteAction=restrict,
> JoinForeignKeyDeleteAction=restrict)
> openjpa.jdbc.QuerySQLCache: true
> openjpa.jdbc.ResultSetType: 1003
> openjpa.jdbc.SQLFactory: default
> openjpa.jdbc.SchemaFactory: native(foreignKeys=true)
> openjpa.jdbc.Schemas: []
> openjpa.jdbc.SubclassFetchMode: 1
> openjpa.jdbc.SynchronizeMappings:
> buildSchema(foreignKeys=true,schemaAction='dropDB,add')
> openjpa.jdbc.TransactionIsolation: -1
> openjpa.jdbc.UpdateManager: default
> 13814  analyticsPU  TRACE  [http-bio-10080-exec-1] openjpa.Runtime - No
> cache marshaller found for id
> org.apache.openjpa.conf.MetaDataCacheMaintenance.
> 13903  analyticsPU  TRACE  [http-bio-10080-exec-1] openjpa.MetaData - Using
> metadata factory
> "org.apache.openjpa.persistence.jdbc.PersistenceMappingFactory@1da817b".
> 13907  analyticsPU  TRACE  [http-bio-10080-exec-1] openjpa.jdbc.JDBC -
> OpenJPA will now connect to the database to attempt to determine what type
> of database dictionary to use. You may prevent this connection in the
> future
> by setting your openjpa.jdbc.DBDictionary configuration property to the
> appropriate value for your database (see the documentation for available
> values).
> 13921  analyticsPU  TRACE  [http-bio-10080-exec-1] openjpa.jdbc.JDBC -
> createConnectionFactory:
>
> DataSource:org.apache.openejb.resource.jdbc.managed.local.ManagedDataSource@121f653
> Oct 1, 2012 10:44:46 AM org.hsqldb.persist.Logger logInfoEvent
> INFO: checkpointClose start
> Oct 1, 2012 10:44:46 AM org.hsqldb.persist.Logger logInfoEvent
> INFO: checkpointClose end
> 14503  analyticsPU  TRACE  [http-bio-10080-exec-1] openjpa.Runtime - No
> cache marshaller found for id
> org.apache.openjpa.conf.MetaDataCacheMaintenance.
> 14503  analyticsPU  TRACE  [http-bio-10080-exec-1] openjpa.MetaData - Using
> metadata factory
> "org.apache.openjpa.persistence.jdbc.PersistenceMappingFactory@1613fe7".
> 14503  analyticsPU  TRACE  [http-bio-10080-exec-1] openjpa.jdbc.JDBC -
> OpenJPA will now connect to the database to attempt to determine what type
> of database dictionary to use. You may prevent this connection in the
> future
> by setting your openjpa.jdbc.DBDictionary configuration property to the
> appropriate value for your database (see the documentation for available
> values).
> 14523  analyticsPU  TRACE  [http-bio-10080-exec-1] openjpa.jdbc.JDBC -
> createConnectionFactory:
>
> DataSource:org.apache.openejb.resource.jdbc.managed.local.ManagedDataSource@121f653
> Oct 1, 2012 10:44:46 AM
> com.adaptiveauth.rest.server.resources.InspectionResourceBase
> postInspection
> INFO: <openjpa-2.2.0-r422266:1244990 fatal general error>
> org.apache.openjpa.persistence.PersistenceException: invalid authorization
> specification - not found: root
>
>
> Don't know what kind of authorization is required for my user 'root' since
> that user has all privileges on the database.
>
>
>
>
> --
> View this message in context:
> http://openejb.979440.n4.nabble.com/Getting-a-persistence-exception-using-openjpa-jta-datasource-tp4657731.html
> Sent from the OpenEJB Dev mailing list archive at Nabble.com.
>