[resolved] Pervasive (Btrieve) Metadata Connection

Seventeen Stars

[resolved] Pervasive (Btrieve) Metadata Connection

hi all
I Have to work with Pervasive Data, but got some problem with metadata connection.
Even if I add classpath in Talend' java build Path class still "not found" .
First Trying with a Talend job : first error come from Class jpscs.jar . Talend can't find it (even if put in Build path) .
Problem resolved with a tLibraryLoad.
But by this way I've to know the schema (and cannot do migration in a Sql Database "on the fly") !
Do a test with a metadata description and Generic JDBC metadata.
But never find the Driver class ! So no way to guess shema from Pervasive database.
How can I make JDBC metadata works with pervasive database ?
Seems that metadata JDBC didn't add classpath of the driver.
env :
Talend Open Studio
Version: 3.1.3
Build id: r26090-20090629-1316

Edit : i've also added the .jar files in Talend lib directory !
thanks for your help
Regards
laurent

Accepted Solutions
One Star TDK
One Star

Re: [resolved] Pervasive (Btrieve) Metadata Connection

Hi
kzone, I'm getting the same message when I download these components:
"Cannot find file"tPervasiveConnection_Component_java.xml" "
Have any thoughts of what can I do about this?
Thanks

All Replies
Seventeen Stars

Re: [resolved] Pervasive (Btrieve) Metadata Connection

Perhaps It could work if I import the jar file missing (jpscs.jar) in the JDBC code !
Where can i found source for metadata JDBC to try that way !?
For example if I add an import "import com.pervasive.pscs.Manager" (Class i'm loadind in tLibraryLoad) in " tJDBCConnection_begin.javajet"
I would be able to use shema editor !??
My goal is to be able to retrieve schemas and avoid to define them by hand (work fine if i do that but it's a long way ) and make a migration from btrieve to Sql database.
++
Seventeen Stars

Re: [resolved] Pervasive (Btrieve) Metadata Connection

ok,
i'm extending JDBC component to working with Pervasive Connection ..(I'll put new Component in the Talend exchange right "onreadystate" Smiley Happy
but it shold be helpfully to be able to use metadata db connection ... !
Suggestion or help will be appreciate
regards
laurent
Seventeen Stars

Re: [resolved] Pervasive (Btrieve) Metadata Connection

.....
With very few modification in the JDBCColumnList (add a PERVASIVE name, ..etc)
, I can read the schema of a pervasive table "on the fly " ... what i'm looking for !
So resolved problem (but hope for some clue to do it with metadta )
Regards
laurent
One Star TDK
One Star

Re: [resolved] Pervasive (Btrieve) Metadata Connection

Hello kzone.
I'm using Pervasive as well and got the same problem that you reported about connection. By a chance, have you posted your component?
Best regards
Seventeen Stars

Re: [resolved] Pervasive (Btrieve) Metadata Connection

hi,
have a look at exchange repository and look for
tJDBCColumnList_extend
tPervasiveConnection
tPervasiveInput
hope it could help you !
laurent
++
One Star TDK
One Star

Re: [resolved] Pervasive (Btrieve) Metadata Connection

Hi
kzone, I'm getting the same message when I download these components:
"Cannot find file"tPervasiveConnection_Component_java.xml" "
Have any thoughts of what can I do about this?
Thanks
Seventeen Stars

Re: [resolved] Pervasive (Btrieve) Metadata Connection

hi,
and hooo Smiley Happy
I'll have a look at this as soon as possible (hope today !)
laurent
EDIT
===
I've downloaded component, unarchived in TOS/plugins/org.talend.designer.components.localprovider_xxx and copied .jar in TOS/lib/java repository and it looks like OK ! (try with TOS Version: 4.0.0M2
Build id: r35653-20100114-0503 )
Use you own repository (@see preferences=>Talend=>components=>path to you user component) if you don't want to share "native" and " imported" talend component !
ps :Are talking about "tPervasiveConnection_java.xml" ?

++
One Star TDK
One Star

Re: [resolved] Pervasive (Btrieve) Metadata Connection

Hi kzone
Sorry, took me some time put my notebook to work ok and get the 4.0M3.
Anyway, i tried with the M3 in talend exchange, download the Pervasive components, but it gave me the same message.
Any clue about what is missing?
Many thanks
Seventeen Stars

Re: [resolved] Pervasive (Btrieve) Metadata Connection

ok ,
i've (re)done the extraction and I see what's wrong ! (i hope Smiley Happy
When you extract Component pervasive connection you've got a repository (tPervasiveConnection_Component) and inside "lib" and "tPervasiveConnection" ....
It's tPervasiveConnection you have to copy in your Talend repository componenet and not tPervasiveConnection_Component ! (it's the reason why talend 's looking for tPervasiveConnection_Component_java.xml )
files "jar" are going into yourTalend/lib/java .
hope it's clear enought
regards
laurent
One Star

Re: [resolved] Pervasive (Btrieve) Metadata Connection

Hi kzone,
I've got the same issue with this solution. As I'm working now with pervasive and this tread is very old, I've posted a new one named : Pervasive DB connection - Syntax Error problem
Any help would be appreciated :-)
Regards,
Mehdi