topic Re: [resolved] Pervasive (Btrieve) Metadata Connection in Talend Studio

[resolved] Pervasive (Btrieve) Metadata Connection

Anonymous — Sat, 16 Nov 2024 13:48:25 GMT

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

Re: [resolved] Pervasive (Btrieve) Metadata Connection

Anonymous — Mon, 24 Aug 2009 14:27:28 GMT

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.
++

Re: [resolved] Pervasive (Btrieve) Metadata Connection

Anonymous — Wed, 26 Aug 2009 11:00:13 GMT

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

Re: [resolved] Pervasive (Btrieve) Metadata Connection

Anonymous — Wed, 26 Aug 2009 12:10:49 GMT

.....
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

Re: [resolved] Pervasive (Btrieve) Metadata Connection

Anonymous — Mon, 08 Mar 2010 14:06:40 GMT

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

Re: [resolved] Pervasive (Btrieve) Metadata Connection

Anonymous — Mon, 08 Mar 2010 18:37:40 GMT

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

Re: [resolved] Pervasive (Btrieve) Metadata Connection

Anonymous — Fri, 12 Mar 2010 18:02:54 GMT

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

Re: [resolved] Pervasive (Btrieve) Metadata Connection

Anonymous — Mon, 15 Mar 2010 08:39:32 GMT

hi,
and hooo
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" ?

++

Re: [resolved] Pervasive (Btrieve) Metadata Connection

Anonymous — Mon, 22 Mar 2010 12:22:18 GMT

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

Re: [resolved] Pervasive (Btrieve) Metadata Connection

Anonymous — Mon, 22 Mar 2010 16:09:07 GMT

ok ,
i've (re)done the extraction and I see what's wrong ! (i hope
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

Re: [resolved] Pervasive (Btrieve) Metadata Connection

Anonymous — Sat, 18 Apr 2015 10:41:40 GMT

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